﻿using System;
namespace BZZ.Model
{
	/// <summary>
	/// 域名提醒实体类：domainTime 。
	/// </summary>
	[Serializable]
	public class domainTime
	{
		public domainTime()
		{}

		#region Model
		private int _id; //id
		private string _siteName; //网站名称
		private string _domain; //域名
		private DateTime? _regDate; //注册时间
		private DateTime? _endDate; //到期时间
		private string _icpno; //备案号
		private string _feeUnit; //续费单位
		private string _memo; //备注
		private string _ext1; //扩展1
		private string _ext2; //扩展2


        /// <summary>
		/// id
		/// </summary>
		public int id
		{
			set{ _id=value;}
			get{return _id;}
		}
        /// <summary>
		/// 网站名称
		/// </summary>
		public string siteName
		{
			set{ _siteName=value;}
			get{return _siteName;}
		}
        /// <summary>
		/// 域名
		/// </summary>
		public string domain
		{
			set{ _domain=value;}
			get{return _domain;}
		}
        /// <summary>
		/// 注册时间
		/// </summary>
		public DateTime? regDate
		{
			set{ _regDate=value;}
			get{return _regDate;}
		}
        /// <summary>
		/// 到期时间
		/// </summary>
		public DateTime? endDate
		{
			set{ _endDate=value;}
			get{return _endDate;}
		}
        /// <summary>
		/// 备案号
		/// </summary>
		public string icpno
		{
			set{ _icpno=value;}
			get{return _icpno;}
		}
        /// <summary>
		/// 续费单位
		/// </summary>
		public string feeUnit
		{
			set{ _feeUnit=value;}
			get{return _feeUnit;}
		}
        /// <summary>
		/// 备注
		/// </summary>
		public string memo
		{
			set{ _memo=value;}
			get{return _memo;}
		}
        /// <summary>
		/// 扩展1
		/// </summary>
		public string ext1
		{
			set{ _ext1=value;}
			get{return _ext1;}
		}
        /// <summary>
		/// 扩展2
		/// </summary>
		public string ext2
		{
			set{ _ext2=value;}
			get{return _ext2;}
		}
		#endregion Model

		#region txt document
		/*
域名提醒,domainTime
id,网站名称,域名,注册时间,到期时间,备案号,续费单位,备注,扩展1,扩展2
id,siteName,domain,regDate,endDate,icpno,feeUnit,memo,ext1,ext2
i,c100,c256,d,d,c100,c200,t,c100,c100


--------------------------
-- 创建表[域名提醒]开始: 
-- alter table  [BZZ_domainTime] add
-- IF EXISTS (SELECT 1 FROM sysobjects WHERE xtype='u' AND name='BZZ_domainTime') drop table BZZ_domainTime
  CREATE TABLE [BZZ_domainTime] (
	 [id] integer IDENTITY (1, 1) PRIMARY KEY NOT NULL ,
	 [siteName] [varchar] (100),
	 [domain] [varchar] (256),
	 [regDate] [datetime],
	 [endDate] [datetime],
	 [icpno] [varchar] (100),
	 [feeUnit] [varchar] (200),
	 [memo] [text],
	 [ext1] [varchar] (100),
	 [ext2] [varchar] (100)
  )

 exec sp_addextendedproperty N'MS_Description',N'域名提醒 ',N'user',N'dbo',N'table',N'BZZ_domainTime', NULL, NULL
 exec sp_addextendedproperty N'MS_Description',N'id',N'user',N'dbo',N'table',N'BZZ_domainTime',N'column',N'id'
 exec sp_addextendedproperty N'MS_Description',N'网站名称',N'user',N'dbo',N'table',N'BZZ_domainTime',N'column',N'siteName'
 exec sp_addextendedproperty N'MS_Description',N'域名',N'user',N'dbo',N'table',N'BZZ_domainTime',N'column',N'domain'
 exec sp_addextendedproperty N'MS_Description',N'注册时间',N'user',N'dbo',N'table',N'BZZ_domainTime',N'column',N'regDate'
 exec sp_addextendedproperty N'MS_Description',N'到期时间',N'user',N'dbo',N'table',N'BZZ_domainTime',N'column',N'endDate'
 exec sp_addextendedproperty N'MS_Description',N'备案号',N'user',N'dbo',N'table',N'BZZ_domainTime',N'column',N'icpno'
 exec sp_addextendedproperty N'MS_Description',N'续费单位',N'user',N'dbo',N'table',N'BZZ_domainTime',N'column',N'feeUnit'
 exec sp_addextendedproperty N'MS_Description',N'备注',N'user',N'dbo',N'table',N'BZZ_domainTime',N'column',N'memo'
 exec sp_addextendedproperty N'MS_Description',N'扩展1',N'user',N'dbo',N'table',N'BZZ_domainTime',N'column',N'ext1'
 exec sp_addextendedproperty N'MS_Description',N'扩展2',N'user',N'dbo',N'table',N'BZZ_domainTime',N'column',N'ext2'

-- 创建表[域名提醒]结束。 
--------------------------

		*/
		#endregion document
	}
}

